package com.projectName.www.dao;

import java.sql.ResultSet;

public class Y_J_select_dao {
    public static ResultSet filltable( ) throws Exception {
        String sql ="select shop.name  ,dishes.name ,shop.description from   shop\n" +
                "left join   dishes\n" +
                "on shop.name=dishes.shopname\n" +
                "union\n" +
                "select shop.name  ,dishes.name ,shop.description from   shop\n" +
                "right join   dishes\n" +
                "on shop.name=dishes.shopname;";
        ResultSet resultSet = BaseDao.executeQuery(sql);
        return  resultSet;
    }

}
